﻿CREATE TABLE [adj].[PlugMapping] (
    [LegalEntityCode]      CHAR (5)    NOT NULL,
    [UnitUniqueCode]       CHAR (7)    NOT NULL,
    [SubAccountCode]       VARCHAR (8) NOT NULL,
    [IsCurrentYearsPnL]    BIT         NOT NULL,
    [IsPriorYearsPnL]      BIT         NOT NULL,
    [IsPnLContra]          BIT         NOT NULL,
    [IsSterlingAdjustment] BIT         NOT NULL,
    PRIMARY KEY CLUSTERED ([LegalEntityCode] ASC, [UnitUniqueCode] ASC, [SubAccountCode] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF)
);

